Database DevOps Recommendations
DevOps and databases aren't always considered compatible, but that is changing. DORA now has recommendations for database changes on their site.
Date and Time Calculations Made Easy with EOMONTH, DATEDIFF, and DATEADD
Learn how to work with dates and calculate particular dates or elapsed time periods with some of the functions available in SQL Server.
Exploring the SQL Server CHOOSE Function
I preface a lot of what I write with whether or not it is for a “practical” use. One of the Simple Talk authors used this function in a forthcoming article. and I realized I hadn’t heard of it before (or I forgot about it… which is not completely unlikely.) The practical use was to generate some data and have at least a little variety to the values.
How Helpful is a GenAI Copilot
Steve looks at a trial using Microsoft's Copilot and how helpful it was for workers.
Level 6 of the Stairway to Synapse Analytics: Dedicated SQL Pool
This next level of the Stairway to Synapse Analysis Services looks at the Dedicated SQL Pool.
SQL Server Cursor Example
I know SQL cursors exist, but I am not sure how or why to use them. Can you provide a SQL cursor example? Can you give any guidance on when to use a SQL Server cursor?
Developer Time is More Valuable Than Ever
Today, Kendra Little talks about how DevOps adoption affects developer productivity and time.
Rising Pay for Certifications
People with certifications are seeing their pay rise faster than others. Steve has a few thoughts on this today.
Building AI Calls into the First Responder Kit
No, that isn’t an April 1st joke, heh. I know a lot of vendors are shoving AI down your throat, but I can think of a few ways I actually want to get quick, easy advice from large language models (LLM) when I’m calling the sp_Blitz scripts:
Just Answer the Question!
I've taken part in online forums since... hoo boy, I was using a dial up modem and had to constantly remind my wife not to pick up the phone while I was using the computer. Man I'm old. Anyway... I've asked a lot of questions over the years, and I've tried to answer them as […]
Blogs
Azure Vulnerability Assessments
Regarding managing databases in the cloud, security should never be an afterthought. That’s where...
Speaking at the NYC Lunch and Learn–May 23
By Steve Jones
In a couple of weeks, I’ll be in New York City for the Redgate...
Your SQL Server Is Whispering…Are You Listening?
By Kevin3NF
Early Warnings of a Meltdown (and How to Catch Them) Most SQL Server crashes...
Forums
Database DevOps Recommendations
Comments posted to this topic are about the item Database DevOps Recommendations
Decoding the Collation II
Comments posted to this topic are about the item Decoding the Collation II
Date and Time Calculations Made Easy with EOMONTH, DATEDIFF, and DATEADD
Comments posted to this topic are about the item Date and Time Calculations Made...
Question of the Day
Decoding the Collation II
In a collation setting, like Latin1_General_100_CI_AS_KS_WS_SC_UTF8, what does the WS mean?
See possible answers